Customizing Excel Pagination Settings for PrizmDoc Server

PrizmDoc Server support two basic pagination modes for rendering Excel documents:

Non-paginated
Paginated

In non-paginated mode, each Excel sheet, irrespective of its size, is rendered onto a single page. If the number of columns and/or rows is large, then this might result in very small and unreadable output. In paginated mode, each Excel sheet is divided into a number of pages, such that each page fits into a specific size.

To customize Excel pagination settings, edit the central configuration file. Modify the following parameters to adjust pagination settings:

Example	Copy Code
fileTypes.excel.pagination.enabled: true fileTypes.excel.pagination.dimensions.minWidth: 11.0in fileTypes.excel.pagination.dimensions.maxWidth: 22.0in fileTypes.excel.pagination.dimensions.minHeight: 8.5in fileTypes.excel.pagination.dimensions.maxHeight: 17.0in

Example

Copy Code

fileTypes.excel.pagination.enabled: true
fileTypes.excel.pagination.dimensions.minWidth: 11.0in
fileTypes.excel.pagination.dimensions.maxWidth: 22.0in
fileTypes.excel.pagination.dimensions.minHeight: 8.5in
fileTypes.excel.pagination.dimensions.maxHeight: 17.0in

fileTypes.excel.pagination.enabled – set to "false" to disable pagination, set to "true" to enable pagination.
fileTypes.excel.pagination.minWidth, fileTypes.excel.pagination.maxWidth, fileTypes.excel.pagination.minHeight, fileTypes.excel.pagination.maxHeight – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the 'fileTypes.excel.pagination.enabled' parameter is set to "false", then these 4 parameters are ignored.

The following configuration properties have been deprecated and will be removed in a future release. Alter these properties only if not using the central configuration file.

To customize Excel pagination settings using legacy configuration, edit the Watchdog configuration file located in the following default directories:

Windows: C:\Prizm\PCCIS\Watchdog\watchdog.config
Linux: /usr/share/prizm/pccis/Watchdog/watchdog.config

Modify the following parameters to adjust pagination settings:

Example	Copy Code
"officeConversionService": { ... "excelPagination":true, "excelPageWidthMin":11.0, "excelPageWidthMax":22.0, "excelPageHeightMin":8.5, "excelPageHeightMax":17.0 ... },

excelPagination – set to "false" to disable pagination, set to "true" to enable pagination.
excelPageWidthMin, excelPageWidthMax, excelPageHeightMin, excelPageHeightMax – non-negative doubles. These parameters specify the minimum and maximum sizes, in inches, for pages dynamically generated in the paginated rendering mode. If the 'excelPagination' parameter is set to "false", then these 4 parameters are ignored.